SUPPORT / SAMPLES & SAS NOTES
Problem Note 52216: FSA Daily Flows (047) Report Fails with Syntax Error in Time Bucket SQL
 |  |  |  |
If you run the FSA Daily Flows (047) report more than once when using the SAS® Risk Reporting Repository for Banking sample data, then every attempt after the first fails with the following errors in the log:
MPRINT(RMB_FSA047_REPORT): proc sql noprint;
NOTE: Line generated by the invoked macro "RMB_FSA047_REPORT".
21 WORK.INTERVAL_TIME_BUCKETS as X, RD_RPT.TIME_BUCKET_DIM as T where X.time_bucket_group_sk = &TIME_BUCKET_GROUP_SK and X.time_bucket_sk
_
22
76
21 ! = T.time_bucket_sk order by 1 ; quit; proc
MPRINT(RMB_FSA047_REPORT): create table WORK.TIME_BUCKETS as select X.sequence_no, X.time_bucket_sk, intnx(T.tb_start_length_uom_cd, datepart(dhms(17822,00,00,00)), T.tb_start_length_no,
'SAME') as actual_date from WORK.INTERVAL_TIME_BUCKETS as X, RD_RPT.TIME_BUCKET_DIM as T where X.time_bucket_group_sk = and X.time_bucket_sk = T.time_bucket_sk order by 1 ;
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, EQT, GE, GET, GROUP, GT, GTT, HAVING, LE, LET, LT, LTT, NE, NET, OR, ORDER,
^=, |, ||, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
As a workaround, you can do the following:
- Create a new time grid with this bucketing scheme:
- Change the time grid that is used by the FSA047 reporting analysis task to the one that you created in step 1.
- Run the FSA047 reporting analysis task.
- Run the FSA Daily Flows report.
Note that this workaround is necessary only when you load and use the SAS Risk Reporting Repository for Banking sample data.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Risk Management for Banking | Microsoft Windows 8 Pro 32-bit | 3.2 | 3.2_M1 | 9.4 TS1M1 | |
| Microsoft Windows 8 Enterprise x64 | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Microsoft Windows 8 Enterprise 32-bit | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Microsoft® Windows® for x64 | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Microsoft Windows 8 Pro x64 | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Microsoft Windows 8.1 Enterprise 32-bit | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Microsoft Windows 8.1 Enterprise x64 | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Microsoft Windows 8.1 Pro | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Microsoft Windows 8.1 Pro 32-bit | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Microsoft Windows Server 2008 | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Microsoft Windows Server 2008 R2 | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Microsoft Windows Server 2008 for x64 | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Microsoft Windows Server 2012 Datacenter | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Microsoft Windows Server 2012 R2 Datacenter | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Microsoft Windows Server 2012 R2 Std | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Microsoft Windows Server 2012 Std | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Windows 7 Enterprise 32 bit | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Windows 7 Enterprise x64 | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Windows 7 Home Premium 32 bit | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Windows 7 Home Premium x64 | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Windows 7 Professional 32 bit | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Windows 7 Professional x64 | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Windows 7 Ultimate 32 bit | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Windows 7 Ultimate x64 | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| 64-bit Enabled AIX | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| 64-bit Enabled Solaris | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Linux for x64 | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||
| Solaris for x64 | 3.2 | 3.2_M1 | 9.4 TS1M1 | |||